﻿CREATE PROCEDURE [dbo].[Student_Select]
	@ID INT = NULL,
	@MemberID INT =NULL,
	@Department NVARCHAR(50)

	AS

	SELECT *
	FROM [Student]
	WHERE
	(
	(@ID IS NULL OR ID = @ID)AND
	(@MemberID IS NULL OR MemberID = @MemberID)AND
	(@Department IS NULL OR Department LIKE @Department)
	)
